Vlookup function Help

[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

 

[Aladin Akyurek]

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.

 

[dinna]

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