×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

using Vlookup and Hlookup in a spreadsheet
2

using Vlookup and Hlookup in a spreadsheet

using Vlookup and Hlookup in a spreadsheet

(OP)
hello everybody,

I have a value (6) in a cell and i want to look it up in a table

1         4
2         11
3         9
4         6
5         3

i want the program to look up 6 and then give the value 4 in another cell

how would one go about this

rugbyboy123

RE: using Vlookup and Hlookup in a spreadsheet

Why do you think reading an explanation here is going to be better than reading an explanation from Excel help?

-handleman, CSWP (The new, easy test)

RE: using Vlookup and Hlookup in a spreadsheet

Your columns are in the wrong order to use VLOOKUP.  (Presumably this is why you are asking the question.)

Use the MATCH function on your second column to find the entry you are seeking.  If your first column is always sequential from unity, then that is your answer.

If on the other hand your first column cannot be assumed to be simply the sequential integers, and just looks that way because you entered your example in great haste, then you need to use the result from the above MATCH function as the row reference into an application of the INDEX function to the first column.  Try the two operations separately first, and once you understand them individually you can combine them into the one formula.
 

RE: using Vlookup and Hlookup in a spreadsheet

(OP)
thats great thank u very much for your help electricpete

regards

rugbyboy123

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources