Hi,
I am looking for help with double vlookup formula for table:
ColumnA____ColumnB_____ColumnC
1____a______red
2____b______
3____b______green
4____b______blue
5____c______white
6____d______black
Lookup table:
ColumnD_____ColumnE______ColumnG
a____________red__________A
b____________ ___________B
c____________white_________C
d____________black_________D
formula: C1=vlookup(A1&B1,lookup tableD1:G4, 3,0)
My problem is:in lookup table E2 (for b in column D) can be any text or even blank (in top data table), and it still should return with B. I do not know how to join D and E if cell value (E2)can be anything.
Hope it makes sense what I am trying to explain.
Thanks a lot
I am looking for help with double vlookup formula for table:
ColumnA____ColumnB_____ColumnC
1____a______red
2____b______
3____b______green
4____b______blue
5____c______white
6____d______black
Lookup table:
ColumnD_____ColumnE______ColumnG
a____________red__________A
b____________ ___________B
c____________white_________C
d____________black_________D
formula: C1=vlookup(A1&B1,lookup tableD1:G4, 3,0)
My problem is:in lookup table E2 (for b in column D) can be any text or even blank (in top data table), and it still should return with B. I do not know how to join D and E if cell value (E2)can be anything.
Hope it makes sense what I am trying to explain.
Thanks a lot