| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is this legal?
I have 2 columns and I am trying to create a validation in which my 2nd
column relies on the input of the 1st. That's fine. But, I need to do a lookup in two different tables on the same sheet. Is what I'm trying to do allowed in Excel. I attempted a formula in my source but I get errors. It's not a parenthesis error or anything like that. Can someone please help? Thanks. =IF(INDIRECT(VLOOKUP(B2,G1:I18,3,0)),(VLOOKUP(B2,J 1:K15,2,0))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing on Legal Size Paper! | Excel Discussion (Misc queries) | |||
| Not all data prints on legal paper but does on other computer. | Excel Discussion (Misc queries) | |||
| Auto Adjust Spread Sheet so it will print on 1 page/legal/landscap | Excel Worksheet Functions | |||
| Sorting 'legal' numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
