Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I use VLOOKUP to find values across more than 1 sheet or Wo
How do I use the VLOOKUP function to find an exact value across more than one
worksheet and Work Book? I have a number of workbooks that I need the function to search through to find the value, but have no idea how to write the formulae to search more than one worksheet, let alone an entirely different work book. |
#2
|
|||
|
|||
Remember, VLOOKUP wil stop on the first match........
=IF(ISNA(VLOOKUP(A1,FirstRange,2,false)),VLOOKUP(A 1,SecondRange,2,false),VLOOKUP(A1,FirstRange,2,fal se)) Vaya con Dios, Chuck, CABGx3 "RVFmal" wrote: How do I use the VLOOKUP function to find an exact value across more than one worksheet and Work Book? I have a number of workbooks that I need the function to search through to find the value, but have no idea how to write the formulae to search more than one worksheet, let alone an entirely different work book. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find the sum of Comma Seperated Values In a Cell | Excel Worksheet Functions | |||
Using VLookup and typing in values to be "looked up" | Excel Worksheet Functions | |||
how do i get mutiple values using vlookup in excel, lookup value . | Excel Discussion (Misc queries) | |||
VLOOKUP: type or paste values | Excel Worksheet Functions | |||
How do you find duplicate values in excel- 2 columns of numbers | Excel Discussion (Misc queries) |