Using a VLOOKUP with an IF this OR that

[traceyq88]

Hi all,

I'm currently trying to get a formula working on Excel and I after lots of Googling and even doing a search on this forum I still can't seem to find the answer - I'm probably not searching using the correct terminology :S

This is the closest I've gotten to get it to work.

=IF(VLOOKUP(B2,Sheet1!A:DE,109,TRUE)="Apples","Yes","No")

The formula above would be perfect, however I want the cell to equal 'Yes' if column 109 on Sheet 1 equals 'Apples' OR 'Pears' and return 'No' if anything else.

Any help would be much appreciated! Please let me know if any more info is needed.

Thanks!
T

[Crooza]

Hi and welcome

I'm not on laptop to check but try this

Please Login or Register  to view this content.

[traceyq88]

Worked perfectly, thank you so much!