Vlookup in if statement?

[Ronix]

Hi Guys,

let´s imagine this.
In first sheet I have in these three columns A, B, C these values:
Column A:
car
boat
Column B:
red
green
Column C:
automatic
manual
How the statement will look like if I need to get respective value into second sheet to the cell D2 and E2?
If I write to the C2 value "boat" I will automatically get value green to the cell D2 and value manual to the cell E2.
And until the value is not in D2 and E2 these cells are empty.
Thx in advance!

 

[Scott T]

Maybe something like this


Excel 2010[TABLE="class: grid, width: 300"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH][/TH]
[TH]A
[/TH]
[TH]B
[/TH]
[TH]C
[/TH]
[/TR]
[TR]
[TD="align: center"]1
[/TD]
[TD]car
[/TD]
[TD]red
[/TD]
[TD]automatic
[/TD]
[/TR]
[TR]
[TD="align: center"]2
[/TD]
[TD]boat
[/TD]
[TD]green
[/TD]
[TD]manual
[/TD]
[/TR]
</tbody>[/TABLE]

Sheet5​

Excel 2010[TABLE="class: grid, width: 400"]
<colgroup><col><col><col><col></colgroup><tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TD][/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]boat[/TD]
[TD]green[/TD]
[TD]manual[/TD]
[/TR]
</tbody>[/TABLE]

Sheet6​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="class: grid, width: 100%"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TD="width: 10"]Cell[/TD]
[TD="align: left"]Formula[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D2[/TH]
[TD="align: left"]=IF(C2="","",VLOOKUP(C2,Sheet5!A1:C2,2,0))[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]E2[/TH]
[TD="align: left"]=IF(C2="","",VLOOKUP(C2,Sheet5!A1:C2,3,0))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Ronix]

Maybe something like this


Excel 2010[TABLE="class: grid, width: 300"]
<tbody>[TR]
[TH][/TH]
[TH]A[/TH]
[TH]B[/TH]
[TH]C[/TH]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD]car[/TD]
[TD]red[/TD]
[TD]automatic[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]boat[/TD]
[TD]green[/TD]
[TD]manual[/TD]
[/TR]
</tbody>[/TABLE]

Sheet5​

Excel 2010[TABLE="class: grid, width: 400"]
<tbody>[TR]
[TD][/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]boat[/TD]
[TD]green[/TD]
[TD]manual[/TD]
[/TR]
</tbody>[/TABLE]

Sheet6​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="class: grid, width: 100%"]
<tbody>[TR]
[TD="width: 10"]Cell[/TD]
[TD="align: left"]Formula[/TD]
[/TR]
[TR]
[TH="width: 10"]D2[/TH]
[TD="align: left"]=IF(C2="","",VLOOKUP(C2,Sheet5!A1:C2,2,0))[/TD]
[/TR]
[TR]
[TH="width: 10"]E2[/TH]
[TD="align: left"]=IF(C2="","",VLOOKUP(C2,Sheet5!A1:C2,3,0))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Great! It works as I need. Thx a lot!