Combining IF and VLOOKUP

jonnyjack27

New Member
Joined
Mar 21, 2011
Messages
2
16. 16/05/2009. H09/5941. A1 HE. 1

Hi, I've got a row in my table as shown above(full stop indicates a new column).

I am trying to combine IF and VLOOKUP to find this row and search the 4th column (A1 HE in this case). I then want the formula to return a "YES" if the cell contains A1 HE and a "NO" if it doesn't.

My forumla below is showing #NAME!

=IF(VLOOKUP(16,'[LAMIOS-18..8.09.xls]Sheet1'!$A$5:$E$31,4,FALSE) =A1 HE,"YES","NO")

The "A1" part of A1 HE is highlighting cell A1, however I don't believe this is the only problem. Would somebody be able to help. Many thanks.
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

JamesW

Well-known Member
Joined
Oct 30, 2009
Messages
1,197
Hi,

Welcome to the board.

Try:

=IF(VLOOKUP(A1,'[LAMIOS-18..8.09.xls]Sheet1'!$A$5:$E$31,4,FALSE) ="A1 HE","YES","NO")

Changes are bold and underlined - Change A1 to whatever cell the value is in.
 

jonnyjack27

New Member
Joined
Mar 21, 2011
Messages
2
Thank you very much. The quotations around A1 HE worked. I didn't have to change the 16 to a cell.

I'm trying to teach myself VLOOKUPS and SUMIFS for an interview tomorrow, although they haven't told me how advanced the forumlas will be. Are there any websites that have questions so that I can practice these techniques? I'm on a mac so I can't download Ribbon Hero, which I have heard is useful.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,001
Messages
5,526,196
Members
409,686
Latest member
Tori83

This Week's Hot Topics

Top