Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
alternative to VLOOKUP
Hi,
What I am looking for is an alternative for the function VLOOKUP. I want to to exactly the operation this function performs, only I do not have the option to sort the data in my array. I am trying the following: Sheet 2; cel A1: = 'Sheet 1'!A14 Sheet 2; cel B1: =INDIRECT("'Sheet 1'!C"&ROW(B3)) Condition: The cel B1 in sheet 2 has to be a reference to Sheet 2 cel A1. My problem is that I cannot get the rownumber from Sheet 1 (= 14 in my example). Thanks for any help!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Which is faster? SUMPRODUCT or VLOOKUP, or another alternative? | Excel Worksheet Functions | |||
vlookup in excel have alternative result than #N/A selectable | Excel Worksheet Functions | |||
Vlookup Alternative Needed | Excel Discussion (Misc queries) | |||
Nested Vlookup or alternative? | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |