• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VLOOKUP - look up table in a different tab

K

kats67

New Member
I am using this formula to look up a data range in a different tab than the location of this formula and get a reference error.

=VLOOKUP(E53,HERS!,3,A1:C23)

E53 is my input cell data Ie "Brentwood"

HERS is the location (name of the tab) in my spreadsheet

3 is the column I need the value

A1:C23 is the range of information

A B C

Capri 54 98.00

Brentwood 56 93.00


Can you tell me what I am doing wrong?


Thanks, David
 
Hi, kats67!


First of all welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here.


As a starting point I'd recommend you to read the three first green sticky topics at this forums main page. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).


Among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.


Feel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, you'll always be welcome back here. Tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you.


And about your question...


Try this:

=VLOOKUP(E53,HERS!A1:C23,3,FALSE)


Regards!


EDIT:

Syntax of VLOOKUP is VLOOKUP (value, matrix, column, [search type])

If you are going to copy the cell with that formula, you might want to fix the matrix reference to HERS!A$1:C$23 if copying to another row or to HERS!$A1:$C23 if copying to another column or to HERS!$A$1:$C$23 to free copy anywhere.
 
Thank you very much. I have another wierd issue. When I try to do a simple formula to only show the contents of another cell the formula shows up instead of the other cells contents.

A1 = Capri

Cell P4 - I type =A1 and =A1 shows up instead of Capri. P4 is actually 3 merged cells, if that matters.
 
Either the cell is formatted as Text or you're in formula view mode. Try hitting Ctrl+~ (tilde key) to toggle formula view mode. If that doesn't fix it, try changing the cell format and then re-enter the formula.
 
You must log in or register to reply here.
Back
Top