Logical Vlookup & index Formula

[howard]

I have a formula that if 95915 or 95925 or 95950 in in Col G, then lookup the description in Col 2 on sheet1 otherwise return the result of the Index formula

where 95915, 95925, 95950 is in Col G, the description from the Vlookup is not being used. I only get the results from the Inde formula

=IF(OR(G1615="95915",G1615="95925",G1615="95950"),VLOOKUP(Sheet1!$A$1:$B$11,2,FALSE),INDEX('[BR1tb(Cat).xls]TB'!$A:$A,MATCH(G1615,'[BR1tb(Cat).xls]TB'!$B:$B,0)))

it would be appreciated if someone could amend my formula

 

[steve the fish]

Remove the inverted commas from your numbers, 95915 rather then "95915". Also your vlookup is invalid so thats needs fixing. You have no lookup value.

 

[howard]

Thanks for your input. have made the changes and it now works

 

[howard]

Hi Steve

the if(or function works with 2 criteria. I get #N/a when I add a 3rd criteria in the logical formula

 =IF(OR(G2=95915,G2=955925,G2=95910),VLOOKUP(G2,Codes!$A$1:$B$7,2),INDEX('[BR1tb(Cat).xls]sheet1'!$A:$A,MATCH(G2,'[BR1tb(Cat).xls]sheet1'!$B:$B,0)))

please check & correct

 

[howard]

Hi Steve


Have found my error-forgot to include false in the Vlookup after the 2 (second column)

=IF(OR(G2=95915,G2=955925,G2=95910),VLOOKUP(G2,Codes!$A$1:$B$7,2,false),INDEX('[BR1tb(Cat).xls]sheet1'!$A:$A,MATCH(G2,'[BR1tb(Cat).xls]sheet1'!$B:$B,0)))