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
Bookmarks