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 can save the Surface Book lineup?

Discuss in The Lounge

Poll History