How to Pick Value of adjacent cell when Search is true

**tushar@excel** · 08-11-2008, 09:55 AM

Hi All,
I want to pick values from adjacent cell, if he search is true.
For Example
Cell A Cell B Cell C Cell D
37156306160 +0000000000100.00 37156306160
37156306167 +0000000000100.00 37156306167
37156306500 +0000000000150.00 37156306641
37156306501 +0000000005000.00 37157306004
37156306501 +0000000002500.00 37157306009
37156306501 +0000000001500.00 37157306010
37156306501 +0000000001500.00 37157306011
37156306502 +0000000005000.00 37157306012

I want to take the first Value from Cell C and Search in Cell A, if the search is true, then pick the adjacent cell value, in this case pick from 1st row of cell B.
Please suggest if VLOOKUP or HLOOKUP or Match can be used successfully or not.

Regards,
Tushar

**Simon Lloyd** · 08-11-2008, 10:03 AM

VLookup or any other search wont do what you want, look at your data in column A you have multiples of the same number, so you would need to go through each of these and PICK the correct answer thats provided you know what the answer would be, i think your looking at VBA to do this but you have to know what criteria it should show or should it show all of them?