Concatenate double Vlookup in One Cell from two table

S

SAXON10

Board Regular
Joined
Jun 1, 2017
Messages
109
Hi,

I am trying to concatenate vlookup formula in one cell from two different table.

I am apply the following formula in formula required sheet but formula return NA.

B9=VLOOKUP(B$2,DATA!$G$4:$K$15,MATCH($A3,DATA!$H$2:$K$2,0)+1,FALSE)&VLOOKUP(B$2,DATA!$A$4:$E$15,MATCH($A3,DATA!$B$2:$E$2,0)+1,FALSE)

How to resolve the error. Please help me.

DATA SHEET:

TABLE 1A2:E15TABLE 2G2:K15
FRUITBLUEBERRYBLACKCURRANTBLACKBERRYBILBERRYFRUITBLUEBERRYBLACKCURRANTBLACKBERRYBILBERRY
ORDERQ1Q2Q3Q4ORDERQ1Q2Q3Q4
3969OKOKOKOK4041QAOKQAOK
4022OKOKOKOK4019OKOKOKOK
3987OKOKOKOK4061OKOKOKOK
3944OKOKOKOK40790000
3994OKOKOKOK4062OKOKOKOK
3996OKOKOKOK40680000
3995OKOKOKOK40690000
4017OKOKOKOK40800000
4067OKOKOKOK40580000
4040QAOKOKOK4000OKOKOKOK
4065OKOKOKOK

<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
FORMULA REQ SHEET:

RANGE A2:V6

FRUIT404140194061407940624068406940804058400039694022398739443994399639954017406740404065
BLUEBERRYQAOKOK0OK0000OK OKOKOKOKOKOKOKOKQAOK
BLACKCURRANTOKOKOK0OK0000OKOKOKOKOKOKOKOKOKOKOKOK
BLACKBERRYQAOKOK0OK0000OKOKOKOKOKOKOKOKOKOKOKOK
BILBERRYOKOKOK0OK0000OKOKOKOKOKOKOKOKOKOKOKOK

<colgroup><col><col span="21"></colgroup><tbody>
</tbody>
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
Sort by date Sort by votes
Hi,

Try This formula in Formula REQ SHEET.

=IFNA(VLOOKUP(B$1,DATA!$A$3:$E$13,MATCH($A2,DATA!$A$1:$E$1,0),0),"")&IFNA(VLOOKUP(B$1,DATA!$G$3:$K$12,MATCH($A2,DATA!$G$1:$K$1,0),0),"")
 
Upvote 0
sureshxcell said:
Hi,

Try This formula in Formula REQ SHEET.

=IFNA(VLOOKUP(B$1,DATA!$A$3:$E$13,MATCH($A2,DATA!$A$1:$E$1,0),0),"")&IFNA(VLOOKUP(B$1,DATA!$G$3:$K$12,MATCH($A2,DATA!$G$1:$K$1,0),0),"")
Click to expand...

Thank you so much for your help formula working fine. I need the same result with index match formula. Please help me.
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question
4 Linear Interpolations... I think.
Replies
3
Views
733
Sal Paradise
S

Forum statistics

Threads
1,214,520
Messages
6,120,016
Members
448,936
Latest member
almerpogi

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top