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

Report •


#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.

DerbyDad03
Office Forum Moderator

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


Report •

#2
October 13, 2013 at 17:26:41
✔ Best Answer
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

http://www.skeptic.com/

message edited by mmcconaghy


Report •

Related Solutions


Ask Question