with the data i have i firstly have to do the lookup by using column a to
match the data however columns b also have to match as they can be different
which is why line 3 is correct (colB is 245 on both sheets) whereas line 2 on
the array column b is 244 this is why i need a formula to search on column b
after the initial lookup.

hope this makes sense

"broro183" wrote:


Hi,
As Bob has said, vlookup isn't that smart - & I may be slightly off
track here, but why is line 3 the correct match?
If it's b/c this row (ie column A value & column B value) is identical
in both the table & the array, what is the point of returning column B
(of array) in column C of the Table (you could just type"=B1")?

If your intention is to return a value from an identical row you need
to use a concatenated helper column (eg, cell C1 contains "=A1&"%"&B1")
for your lookup/matching or a sum product formula.

Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=539199