| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using text from cell in a range lookup
I'm doing a vlookup across multiple tabs and I have one summary sheet.
All of the lookup values are listed on the summary tab along with their tab designation (ie A1 = Doe, John, A2 = MW Region). Would it be possible to do a vlookup in this summary tab using these references? For example, would it be possible to do vlookup(A1, A2!$A$23:$D$320,4,false) I want to be able to have the vlookup search in the right tab without having to change the formula for each section. Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using text from cell in lookup formula | Excel Worksheet Functions | |||
| use cell text in lookup function | Excel Worksheet Functions | |||
| Referencing cell text in a lookup | Excel Discussion (Misc queries) | |||
| Lookup certain text within a cell, PLEASE HELP! | Excel Worksheet Functions | |||
| lookup a text cell and return text | Excel Discussion (Misc queries) | |||
Threaded Mode
