| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup into 2 shhets
Hi
Used search to find this off biff Sheet1=SSA (lookup table) B2 Sheet2=Oasis Pemb C2:H2 Sheet3=Oasis Minor C2:H2 used this formula and go empty cell. 3 being the 3rd column from+incl.C2. =IF(ISERROR(VLOOKUP(B2,Oasis Pemb!C2:H2,3,0)),IF(ISERROR(VLOOKUP(B2,Oasis Minor!C2:H2,3,0)),"",VLOOKUP(B2,Oasis Minor!C2:H2,3,0)),VLOOKUP(B2,Oasis Pemb! C2:H2,3,0)) What am i doing wrong. Want a n/a if false regards Brian -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200602/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
| VLOOKUP Limitations | Excel Worksheet Functions | |||
| Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Threaded Mode
