Question description:
This user has given permission to use the problem statement for this
blog.
hi, I want to do a vlookup, but look up one reference, but lookup from 8 different columns to bring back data from another column, then drag the formula to bring up the rest of the data from another column
Solved by G. W. in 30 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
02/03/2018 - 12:47
Hi
User
02/03/2018 - 12:47
hi
Excelchat Expert
02/03/2018 - 12:47
do you have existing excel file?
Excelchat Expert
02/03/2018 - 12:48
with values?
User
02/03/2018 - 12:48
ok give me a sec and i will compile one for you
Excelchat Expert
02/03/2018 - 12:49
so what will be the problem here?
User
02/03/2018 - 12:49
so basically i want to look up b1, to d to k4, then bring back the value from l1 to4
Excelchat Expert
02/03/2018 - 12:50
there is no value in b1
User
02/03/2018 - 12:50
exactly, so b1 should return l1
Excelchat Expert
02/03/2018 - 12:50
oh i see
User
02/03/2018 - 12:50
sorry l2
Excelchat Expert
02/03/2018 - 12:51
b1 or b2/
User
02/03/2018 - 12:51
b2
User
02/03/2018 - 12:51
sorry
Excelchat Expert
02/03/2018 - 12:52
then from column D, where will i go?
User
02/03/2018 - 12:52
may be i didnt explain correctly
User
02/03/2018 - 12:52
imagine a normal vlookup,
Excelchat Expert
02/03/2018 - 12:53
so first step is to find BAA1000 in column D?
Excelchat Expert
02/03/2018 - 12:53
is it correct?
User
02/03/2018 - 12:53
you would lookup a2, and the table array will be d to l. and the return value will be what is in L
User
02/03/2018 - 12:53
but i want to lookup mulitple fields to bring up the data in col L
Excelchat Expert
02/03/2018 - 12:55
did i get it right?
Excelchat Expert
02/03/2018 - 12:55
this is a normal vlookup
User
02/03/2018 - 12:55
thats the correct data you have returned
User
02/03/2018 - 12:56
but I wanted to use multiple lookups from d to K
Excelchat Expert
02/03/2018 - 12:56
just drag down my formula
Excelchat Expert
02/03/2018 - 12:57
anything else?
User
02/03/2018 - 12:58
i dont think this it
Excelchat Expert
02/03/2018 - 12:58
please explain what you wanted to have
Excelchat Expert
02/03/2018 - 01:00
PAL8100 is not in column D to K so an error was returned
User
02/03/2018 - 01:01
You see a3 has bought back n/a
Excelchat Expert
02/03/2018 - 01:01
if you have the full table, it will not return an error
User
02/03/2018 - 01:01
it should bring back Ps10081
User
02/03/2018 - 01:02
but the table is going across
User
02/03/2018 - 01:02
I want it to look up the value in dtok
User
02/03/2018 - 01:02
d to k
User
02/03/2018 - 01:02
not just D
User
02/03/2018 - 01:02
i know how to do a vlookup, but i want to look up multiple ref
Excelchat Expert
02/03/2018 - 01:02
all the values in one column?
User
02/03/2018 - 01:03
so L is what I want to return
User
02/03/2018 - 01:03
but the lookup needs to look up d to k and return L once it matched what is in column A
Excelchat Expert
02/03/2018 - 01:04
i get some of your thoughts
Excelchat Expert
02/03/2018 - 01:11
can you try and check the formula again
Excelchat Expert
02/03/2018 - 01:11
?
User
02/03/2018 - 01:12
ok one min pls
Excelchat Expert
02/03/2018 - 01:12
i think i got it right
User
02/03/2018 - 01:14
yes i think thats it
User
02/03/2018 - 01:14
nks
User
02/03/2018 - 01:14
i just need to amend the formula to my spreadsheet now
User
02/03/2018 - 01:15
as i have the data on a different tab etc
User
02/03/2018 - 01:15
thank you for this
Excelchat Expert
02/03/2018 - 01:15
ok great
Excelchat Expert
02/03/2018 - 01:15
please rate our session when it ends, thanks
User
02/03/2018 - 01:16
will do thanks
Excelchat Expert
02/03/2018 - 01:16
thank you
User
02/03/2018 - 01:16
thank you
User
02/03/2018 - 01:16
bye
Excelchat Expert
02/03/2018 - 01:16
bye
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.