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
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
-handleman, CSWP (The new, easy test)
RE: using Vlookup and Hlookup in a spreadsheet
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
=OFFSET(valuerange,MATCH(6,valuerange,0)-1,-1,1,1)
where valuerange refers to the 2nd column of your example
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: using Vlookup and Hlookup in a spreadsheet
regards
rugbyboy123