Vlookup function Help

  • Thread starter Thread starter dinna
  • Start date Start date
D

dinna

I need to lookup a value based on 3 criterias.

Wkst 1
col1 col2 col3 col4 col5
ABC 234 01 $10 $40
XYZ 146 01 $22 $33
ABC 234 02 $9 $65

Wkt 2
col 1 col2 col3 col4 col5
ABC 234 01 ? ?
XYZ 146 01 ? ?
ABC 234 02 ? ?


What is the best way to fill in the ? with the data from wkst 1(col4 &
col5). I can't do a vlookup function because I want all 3
columns(col1, col2, col3) to match so I can bring forth col4 and col5.


Thanks
dinna
 
Insert a column before column A in worksheet1.

In A2 enter (assuming the data starts in A20) and copy down;

=B2&CHAR(127)&C2&CHAR(127)&D2

In E2 on worksheet2 enter:

=VLOOKUP($A2&CHAR(127)&$B2&CHAR(127)&$C2,Sheet1!$A$2:$F$4,5,0)

Likewise in F2.
 
Thanks very much for your help

However, worksheet 1 is imported data in which I can't change the
format of the data. I do know that the 3 columns will be in worksheet
1. And in worksheet 2, I will have 3 columns. I will just need to
bring forth the ?.

So, is there a way to do this without changing worksheet 1's format.

thanks
dinna
 
Back
Top