| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you do two Vlookup tables in one sheet?
I am having an issue in a file where I have three sheets and I am attempting
to combine VLOOKUP results into the third sheet. The second VLOOKUP does not appear to be working correctly. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you do two Vlookup tables in one sheet?
Try something like this.........if you still have trouble, post what you are
trying and what results you're getting....... =IF(ISNA(VLOOKUP(A1,SHEET1!A:B,2,FALSE)),VLOOKUP(A 1,SHEET2!A:B,2,FALSE),VLOOKUP(A1,SHEET1!A:B,2,FALS E)) Vaya con Dios, Chuck, CABGx3 "Bob C" wrote: I am having an issue in a file where I have three sheets and I am attempting to combine VLOOKUP results into the third sheet. The second VLOOKUP does not appear to be working correctly. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy completely same tables into one sheet | Excel Discussion (Misc queries) | |||
| Lookup function and compare | Excel Discussion (Misc queries) | |||
| how do i use vlookup to search for a value on another sheet? | Excel Worksheet Functions | |||
| Vlookup a part of a cell value in another sheet | Excel Worksheet Functions | |||
| Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Linear Mode
