Quote:
Originally Posted by FluidPowerOne
I suppose that I should add that I since I had to chop down the workbook to fit for uploading you won't find the 'H-MC' sheet that I spoke of previously nor any of the information "to the right" of the assembly number and model codes in sheet 'H-DATA'.
None the less, the problem persists even without the additional data.
|
Help from
Brazil
Good Morning
FluidPowerOne.
A) "...Looking at sheet 'Look-up Sheet' you'll find the aggravating "#N/A" that I am speaking of..."
Answer: The main question is: You´re comparing a
NUMBER format
'Look-up Sheet' F2 to a
TEXT format
'H-DATA' Column D
Try to use this one at:
'Look-up Sheet' D4
Before: =INDEX('H-DATA'!C2: D300,MATCH('Look-up Sheet'!F2,'H-DATA'!D2: D300,0),1)
Now...: =INDEX('H-DATA'!C2: D300,MATCH(
TEXT('Look-up Sheet'!F2
,0),'H-DATA'!D2: D300,0),1)
Tell me if it worked for you.
Have a nice Day.