Hi, Can I get help with a VLOOKUP formula I have a excel spreadsheet that has 3 sheets in it I am trying to look up data from sheet 3 from column D rows 2 through to 76 and if it matches in sheet 2 data from column H rows 2 through to 117, I would like it to put a Y in a column J where the data matched and a N if no match found from sheet 3, I would also like it to put temperature reads in if matched in column K getting information from sheet 3 from column F rows 2 to 76. Thanks

Before we address your question, here's a posting tip: When posting in a Help forum such as this, please try to use a subject line that gives us a little detail about your question. Considering the hundreds of questions posted in this forum, if everyone used a generic subject line such as "Help With Excel Formulas" we wouldn't be able to tell one question from another.

I have edited the subject line for this question.

DerbyDad03

Office Forum Moderator

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

I think this is what your looking for, try this: On Sheet 2, in cell J2 enter the formula:

=IF(ISNA(MATCH(H2,Sheet3!$D$2:$D$76,0)),"N","Y")

Drag down to J117

This will check to see if there is a Match between cell H2

and any cell in the range D2 thru D76 on sheet 3.On Sheet 2, in cell K2 enter the formula:

=IF(J2="N","",VLOOKUP(H2,Sheet3!$D$2:$F$76,3,0))

Drag down to K117

First we check cell J2 and see if there is a Match,

if TRUE we then do a VLOOKUP to get the temperature reading.See how that works.

MIKE

message edited by mmcconaghy

Ask Your Question

Weekly Poll

Do you think Microsoft's new Surface Go will be a hit?

Discuss in The Lounge

Poll History