| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i use vlookup to search for a value on another sheet?
I have 2 sheets
Sheet 1 contains value to search for sheet 2 contains column 1 with range of values sheet 2 column 2 contains corresponding values to return to sheet 1 I have the formula set up as this =VLOOKUP(B2,sheet2!A2:A84,2,0) It gives me a #REV! error |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
| Using a cell reference of a sheet in Vlookup | Excel Worksheet Functions | |||
| Using Search with either vlookup or match and index | Excel Worksheet Functions | |||
| how do i search an excel sheet for links to another spreadhseet? | Excel Discussion (Misc queries) | |||
| spread sheet search | Excel Discussion (Misc queries) | |||
Threaded Mode
