| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF and LOOKUP formulas
Please enter this pressing <CTRL<SHIFT<ENTER together
shail wrote: Hi I guess one can do it this way to lookup multiple sheets sheet1 AB1001 200 AB1002 300 sheet2 BC1001 500 BC1002 400 sheet3 CD1001 600 CD1002 700 The formula will be =IF(OR(sheet1!A1:A2=A1),VLOOKUP(A1,sheet1!A1:B2,2, FALSE),IF(OR(sheet2!A1:B1=A1),VLOOKUP(A1,sheet2!A1 :B2,2,FALSE),IF(OR(sheet3!A1:A2=A1),VLOOKUP(A1,she et3!A1:B2,2,FALSE),""))) Hope this helps. Thanks, Shail Gord Dibben wrote: Sue From here we can't see your data or your formula. Could you paste a sample of your data and formula(s) that "don't work"? Gord Dibben MS Excel MVP On Fri, 8 Dec 2006 10:04:00 -0800, Sue wrote: I have three different worksheets and I am trying to use IF and LOOkUP formulas to search two of the three worksheets for a specific result... I was just using the LOOKUP function when I had just one worksheet to look at, but now I want it to search two worksheets and thought using the if with the lookup but... but the logical test is returning a "false" result even though it found the correct result. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup formulas | Excel Worksheet Functions | |||
| Lookup formulas | Excel Discussion (Misc queries) | |||
| Lookup Tables and Formulas | Excel Worksheet Functions | |||
| Lookup formulas: Must manuly type in look up value over downloaded value | Excel Discussion (Misc queries) | |||
| How do I highlight all lookup formulas in a worksheet in one shot. | Excel Discussion (Misc queries) | |||
Threaded Mode
