Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup in several sheets
Hi
I want to make the range in my vlookup formula variable. If for example I use the account from 2200 into 2300, I want the vlookup to change it's search range automaticly to this new range My formula is =vlookup(+c11;+c12;3;false) and c11=206 and c12=tabel2300 -- Greetz Kris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup over multiple sheets | Excel Worksheet Functions | |||
add values using vlookup over multi sheets | Excel Discussion (Misc queries) | |||
vlookup over 2 sheets? | Excel Worksheet Functions | |||
Vlookup from 2 different sheets | Excel Worksheet Functions | |||
VLOOKUP across all sheets in a workbook | Excel Worksheet Functions |