Lookup returning an incomplete result from a separate sheet in the same Excel file.

Choice95

New Member
Joined
Mar 23, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
I have Lookup returning a couple of results into a separate page. Three out of the four cell return the exact value I am looking for, but the fifth one is not.

The first three columns are Product Name, Product Form, QTY. They are pulling information that is either entered directly into the referenced cell or a simple link (i.e cell b12 = b11.)

The fourth cell is a 44 digit GS1 code that is displayed correctly in the cell I am trying to look it up it from, but the displayed code in that cell is put together using: eg "=CONCAT("(01)",N142,"(13)",H142,"(10)",J142)"

When it display the lookup, I am only getting (in this example) H142 and J142 returned properly. N142 is itself a CONCAT: eg "=CONCAT("00",K171,L171)", but the output is displayed as 00.
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Watch MrExcel Video

Forum statistics

Threads
1,129,498
Messages
5,636,665
Members
416,935
Latest member
Atulcp

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