# VLOOKUP - combine 2 cells in table array

#### iainmartin100

##### New Member
Hi all,

I'm stuck with a simple vlookup, well it would be simple if I knew the answer.

Im doing a lookup to an external source but the external source has the refrance I want to look up in coloumns A & B.

Example
If the lookup value of "1234" was in colomn A the below would be fine:
=VLOOKUP("1234",[Book1]Sheet1!\$A\$1:\$C\$20,3,FALSE)
But unfortunatly in Coloum A is "12" and in coloumn B is "34"
And I can't insert a new column at the start of the table combining the two as this is a daily generated file from a system.

Below is a simplifed example of the external data and what Im trying to lookup and return:-
A B C
1 12 34 V
2 23 45 W
3 34 56 X
4 45 67 Y
The answer in this case should be "V"
So how do I combine columns A&B on the table array?

Many thanks

### Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
Hi all,

I'm stuck with a simple vlookup, well it would be simple if I knew the answer.

Im doing a lookup to an external source but the external source has the refrance I want to look up in coloumns A & B.

Example
If the lookup value of "1234" was in colomn A the below would be fine:
=VLOOKUP("1234",[Book1]Sheet1!\$A\$1:\$C\$20,3,FALSE)
But unfortunatly in Coloum A is "12" and in coloumn B is "34"
And I can't insert a new column at the start of the table combining the two as this is a daily generated file from a system.

Below is a simplifed example of the external data and what Im trying to lookup and return:-
A B C
1 12 34 V
2 23 45 W
3 34 56 X
4 45 67 Y
The answer in this case should be "V"
So how do I combine columns A&B on the table array?

Many thanks
Try...

Control+shift+enter, not just enter:

=INDEX(\$C\$2:\$C\$5,MATCH("1234",\$A\$2:\$A\$5&\$B\$2:\$B\$5,0))

Perfect, thanks for your help.
Have to say iv'e never used the INDEX function so it's great to learn a new trick.

Perfect, thanks for your help.
Have to say iv'e never used the INDEX function so it's great to learn a new trick.

You are welcome. Thanks for providing feedback.

Replies
1
Views
199
Replies
11
Views
208
Replies
3
Views
620
Replies
5
Views
254
Replies
1
Views
181

1,196,263
Messages
6,014,315
Members
441,814
Latest member
youngstubbs

### 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?

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