good evening everyone
I have my query as Lookup on multiple value (separated by space) then return values to multiple columns:
Here's my sheet 1:
Column A ---------------------Column B--Column C--Column D
Data -------------------------Invoice 1 - Invoice 2 - Invoice 3
531351 861351 516835 ----------- ?--------- ? --------?
Here's on my sheet 2:
Column A -- Column B
Invoice------- Data
Inv50551 --- 531351
Inv50552 --- 861351
Inv50553 --- 516835
I would like to return the looked up values to Invoice 1, 2, 3 columns
I hope I have give the problem clearly and Thhhhhhhhhhhhaaaaaaaaaaannkkkkkkkkkk you so much excel genuises for your kind help
I have my query as Lookup on multiple value (separated by space) then return values to multiple columns:
Here's my sheet 1:
Column A ---------------------Column B--Column C--Column D
Data -------------------------Invoice 1 - Invoice 2 - Invoice 3
531351 861351 516835 ----------- ?--------- ? --------?
Here's on my sheet 2:
Column A -- Column B
Invoice------- Data
Inv50551 --- 531351
Inv50552 --- 861351
Inv50553 --- 516835
I would like to return the looked up values to Invoice 1, 2, 3 columns
I hope I have give the problem clearly and Thhhhhhhhhhhhaaaaaaaaaaannkkkkkkkkkk you so much excel genuises for your kind help
Last edited: