Multiple Vlookups in one cell

[MuhametH]

hello all,

i have looked around and couldnt find an answer to my question so i thought i would try here. I am semi new to excel so please bear with me.

I2 is the cell that needs to have the 2 different vlookups in it. Vlookup #1 will look at cell A2 (which is a part number) and if it is a certain number then it will either put N/A in cell I2 or will leave it blank. If cell I2 is blank ,after going through Vlookup #1, then Vlookup #2 will look at cell H2 (which is qty received) and will fill in cell I2 with the a qty that is appropriate according to the chart that I made (example: if the qty in cell H2 is 15-90 then it will put 13 in cell I2). I apologize if this is overly complicated. Let me know if I need to simplify, Thank you in advance.

vlookup #1- =VLOOKUP(A2,'item listing'!$A$3:$C$1771,3,FALSE)
vlookup #2- VLOOKUP(H2,Sheet1!A4:B10003,2,FALSE)

 

[CodeNinja]

based on your description, you are looking for this formula:
=if(VLOOKUP(A2,'item listing'!$A$3:$C$1771,3,FALSE)="",VLOOKUP(H2,Sheet1!A4:B10003,2,FALSE) ,"N/A")

But I am not sure exactly what you want, so please provide a small sample of data and what you would expect to see under two or 3 conditions.

Good luck,

CN.

 

[MuhametH]

[TABLE="width: 1361"]
<tbody>[TR]
[TD]
A
PART NUMBER[/TD]
[TD]
B
DESCRIPTION[/TD]
[TD]

C
SUPPLIER[/TD]
[TD]

D
DATE[/TD]
[TD]

E
PO #[/TD]
[TD]

F
RTV #[/TD]
[TD]

G
STATUS[/TD]
[TD]

H
QTY REC.[/TD]
[TD]

I
QTY. INSP,[/TD]
[TD]

J
QTY REJ.[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 1290"]
<tbody>[TR]
[TD="class: xl69, width: 124"]912345678[/TD]
[TD="class: xl72, width: 285"]**********[/TD]
[TD="class: xl69, width: 305"]**********[/TD]
[TD="class: xl70, width: 100"]8/7/2015[/TD]
[TD="class: xl69, width: 119"]2433[/TD]
[TD="class: xl68, width: 126"]N/A[/TD]
[TD="class: xl68, width: 78"] PASS[/TD]
[TD="class: xl73, width: 75"]26[/TD]
[TD="class: xl71, width: 78"]13[/TD]
[/TR]
</tbody>[/TABLE]



So basically if A2 is a certain number then I2 would either be N/A or be blank (thats the first vlookup)
and if after that I2 is blank the second vlookup would look at H2 and fill in I2 according to the chart (which is used for vlookup #2)

I want vlookup #1 to run first and if the cell is still blank after that then i want vlookup #2 to run.

I hope that helps.

 

[CodeNinja]

more info needed... please provide a sample table for A2 and H2 lookup and results you want to see...