# Solved Help With VLOOKUP Across Multiple Sheets

October 13, 2013 at 00:40:49
Specs: Windows 7
 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

See More: Help With VLOOKUP Across Multiple Sheets

#1
October 13, 2013 at 13:00:56
 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.DerbyDad03Office Forum Moderator

Report •

#2
October 13, 2013 at 17:26:41
 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 J117This 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 K117First 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.MIKEmessage edited by mmcconaghy

Report •

Related Solutions