LOOK UP VALUE in DB and FILL MISSING VALUES in ANOTHER XLS file

[sealpino]

HI

THX FOR LOOKING

I have a working sheet "STAT TEST" that will have missing data in two columns.
I have a simple database where values are located, see "DB1".

I want to look up the values in column 1 for each row in STAT TEST and get missing data in two columns!

Easy task for someone but hard for me
Thanks in advance

[canapone]

Hi.


formula needs to read "text numbers" as numbers in column E before matching data


In B5 (sheet1) to be copied down


=INDEX([DB1.xlsx]Blad1!D$2:D$6,MATCH(A5+0,INDEX([DB1.xlsx]Blad1!$E$2:$E$6+0,),0))

Hope it helps

[sealpino]

Thx for reply with formula.

Though the entire text does not become any
STILL writes the formula, yes I have translated INDEX and MATCH to SWEDISH
what could be wrong

I uploaded what I see!
A small favor load the file in B5 in STAT test file?

[JeteMc]

Try:
1. selecting cells B5:B9 and utilizing the clear > clear all feature
2. make sure that the format of cells B5:B9 is general
3. modify the formula from post #2 to include single quotes around the '[workbook]sheet'! i.e.

=INDEX('[DB1.xlsx]Blad1'!D$2:D$6,MATCH(A5+0,INDEX('[DB1.xlsx]Blad1'!$E$2:$E$6+0,),0))

Let us know if you have any questions.

[sealpino]

I tried that, I send the file to exemplify

thx for assisting!

[avk]

In Stat Test "B5"

=IFERROR(INDEX([DB1.xlsx]Blad1!$D$2:$D$6,MATCH($A5,[DB1.xlsx]Blad1!$E$2:$E$6,0)),"")

"C5"

=IFERROR(INDEX([DB1.xlsx]Blad1!$F$2:$F$6,MATCH($A5,[DB1.xlsx]Blad1!$E$2:$E$6,0)),"")

[sealpino]

THANKS AGAIN FOR YOUR ADVICE AND HELP FROM "AVK" and "JeteMc"
Have also given creds to "Add Reputation"
I find it naturally to do that when given assistance!
THX

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.