VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
look up value is iv1
table array is A1 TO Z500
How do i get it to look up IV1 in column C and return value in column A?
any help
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
look up value is iv1
table array is A1 TO Z500
How do i get it to look up IV1 in column C and return value in column A?
any help
Here's an example workbook
http://www.freewebs.com/davesexcel/V...20Example2.xls
thats fine but how do i change it from using the first column in the data range. I need it to use column C.third column
Hi,Originally Posted by khalid79m
Vlookup does not work backwards, you will require index match....
http://www.contextures.com/IndexMatchSample.zip
at
http://www.contextures.com/xlFunctions03.html
I dont follow, can anyone give me any guidance, i havent used these functions before.
http://www.mrexcel.com/tip021.shtml
gives a good explanation of using index match
i finally cracked it.. index match.. really appreciate your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks