| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Using vlookup on two worksheets
Right now I am using vlookup To lookup a name in one worksheet. I
would like to look for that name in two different worksheets. Specifically to look for a matching name in the first worsheet and if you don't find it look in the second worksheet. Here is the function I am using now. I suspect I will have to use nested if functions but nothing is working right. =IF(C4500="","",VLOOKUP(C4500,WOOKSHEET1!A:E,3,FAL SE)) Thank you, Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
| vlookup over multiple worksheets | Excel Worksheet Functions | |||
| Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) | |||
Threaded Mode
