Offset and Vlookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This thread was posted earlier today, I'm attempting to accomplish the same outcome in my spreadsheet. I was wondering if anyone could expound on an explination of the syntax a bit more? I'm not sure I follow..

Thankyo

---------------------------------------------------------
Use offset instead lik

=OFFSET(A1,MATCH(E1,A1:A10,0),1

where A1 is the leftmost top value, it will be the equivalen

=VLOOKUP(E1+one below if it worked,A1:B10,2,FALSE


--
For everyone's benefit keep the discussion in the newsgroup

Regards

Peo Sjoblo
 
Hi
the OFFSET function in your case has the following syntax:
OFFSET(start_reference,row_shift,column_shift)
the MATCH function returns the row number for the match of E1 in A1:A10

As this value is used as row_shift the following will happen. e.g. the
value is found in cell A8:
- MATCH returns 8 in this case.
- The OFFSET function would look like
=OFFSET(A1,8,1)
this shifts the reference from A1 8 rows down (that is A9) and then one
column to the right (B9)
 
Back
Top