Lookup problem from excel 2007 [Closed]

 Blocked Profile -

Just want to seek for assistance about my problem for lookup data.Actually i have data as per below.

PO Items Qty
0001 a 2
0001 b 10
0001 c 33
0002 aa 44
0002 bb 22

i just want to get the value for PO 0001 under item b. is this possible?

Hope it make sense.

1 reply


Please, bare in mind that before any answer given on the forum, you should know that there are volunteers who give their time trying to solve user problems. They do have a life other than this forum including me.

Therefore, it is specifically requested from Kioskea forum users to show their respect. For this, the use of polite expressions is a minimum.

To say please, thank you, appreciate, grateful, etc... is common courtesy when you want something, especially help!

You must copy, modify and repost your message respecting the politeness charter.

We trust that you understand.


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!