Vlookup with multiple entries in each cell

zeta

New Member
Joined
Aug 4, 2022
Messages
2
Office Version
  1. 365
Platform
  1. Windows
I have a spreadsheet with a vlookup table which returns a value in a column from a pivot table on another spreadsheet. However, the lookup value value have numeric values in multiple rows and with my vlookup formula it only returns the first value in the table array. Is there a formula or mod to the vlookup formula to allow this to work on both the cells and return as one value? E.g. Could INV0000238 have a formula that returns
70 000 000 in one cell instead of 64 000 000 and have have to manually add the 6 000 000 cell?
=vlookup("INV000235";'Sheet TEST'!$A$2:$B$4;2;FALSE) this is the formula I use now and returns 64 000 000.



Sheet TEST
A B
Investor No.Value
INV0000235
64 000 000​
INV0000235
6 000 000
INV0000355
50 000 000
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

gargamalebarbosa

Board Regular
Joined
Aug 4, 2022
Messages
73
Office Version
  1. 365
Platform
  1. Windows
Try this one.

1659646089460.png
 
Solution

Forum statistics

Threads
1,181,633
Messages
5,931,104
Members
436,775
Latest member
Taproot007

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
Top