VLOOKUP multiple criteria

[Heinrich Venter]

Good day

I need to import a value (text) with VLOOKUP. But it must only import it if the two values are the same.

This is the formual i used:

=IF(AND(VLOOKUP($A13, '[Trend lookup Sep.xls]VB SCRIPT'!A$2:A$141,1,0),(VLOOKUP($D13, '[Trend lookup Sep.xls]VB SCRIPT'!B$2:B$141,1,0))),VLOOKUP($A13, '[Trend lookup Sep.xls]VB SCRIPT'!A$2:C$141,3,0))

It looks at the right values but only returns a #value! in the correct cells.

I have attached the 2 files im using for more information.

Please help?

Kind regards
Heinrich

[martindwilson]

if you are looking for where 2 values match in 2 different columns on the same row and want to return from a third
index('[Trend lookup Sep.xls]VB SCRIPT'!c$2:C$141,match(a13&d13,index('[Trend lookup Sep.xls]VB SCRIPT'!A$2:A$141& '[Trend lookup Sep.xls]VB SCRIPT'!B$2:B$141,0),0)

[Heinrich Venter]

Hi martindwilson

Thank you it worked )

Have a nice day.

Kind regards
Heinrich

[ShosMeister]

Hard to see anything wrong without a sample. According to documentation the only time VLookup should return a #value error is when the index is < 1.

[martindwilson]

=AND(VLOOKUP(B1,$D$1:$D$9,1,0),VLOOKUP(B2,$E$1:$E$9,1,0)) if both results are text or one text the other a number =#value, if either is 0 then false if results are both numbers greater than 0 result is true,

[nageshpolu]

guys it is taking toomuch of time in giving results could you please help me