Reverse VLOOKUP

M

Matt

Okay,
I need help with pulling data when the Col_Index_Num is to the left of the
lookup value in the array. I tried the following, with a negative 7 thinking
it would do the opposite...drive 7 rows to the left but it did not work.

=VLOOKUP(A1,Sheet2!A:H,-7,FALSE)
In this formula, the lookup value would have been in column H.

Thanks
 
B

Bob Phillips

=INDEX(Sheet2!A:A,MATCHA1,Sheet!H:H,0))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

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 from right to left 2
vlookup - Col_index_num 10
offset within vlookup 6
Dynamic col_index_num in VLOOKUP? 5
EXCEL - IF(IFERROR(VLOOKUP question 0
VLookup 1
Copying functions without changing most variables in it 3
Case Sensitive v-lookup needed 3

Top