Need help in VLOOKUP function

L

Leow

Good day,
I hope the experts and guru can help me on this problem.
Here is what I have:-
Table 1, name "SHS" defined as H2:K10
Table 2, name "FB" defined as M2:p5
Column A will be input either SHS or FB, eg A1 -- SHS
in Cell B1, I want it to lookup a data from table SHS,
so, I input a formula like =vlookup(3;A1;2) which I wanted it to return a
value from table SHS 2nd column from row containing 3 at 1st column.
Obviously, it didn't work since it looked in CELL A1 instead of table SHS.
How should I edit the formula to get what I want? I tried to use IF
function but I will be too long since I actually have about 10 tables. Your
help is very appreciated.
thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup useful? 2
Macro question lookup useful? 1
Vlookup Help 2
vlookup Function 2
Vlookup to reference offset 1
Vlookup Function 3
Need VLOOKUP to Work Two Ways 0
Vlookup and return sheet name also 2

Top