| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need to do a look up from another sheet
I need to do a look up from sheet 3 that has 380 items on it. I need it to
show when I start typing the material on sheet 1. Is this at all possable |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
need to do a look up from another sheet
What do you mean by "start typing"?
Probably VLOOKUP function will do the trick, but only after you have entered a value, not when you start typing. Gord Dibben MS Excel MVP On Tue, 23 Mar 2010 11:53:01 -0700, ttabler128 wrote: I need to do a look up from sheet 3 that has 380 items on it. I need it to show when I start typing the material on sheet 1. Is this at all possable |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
| Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
| "='sheet 1'!D4" auto fill sheet to sheet ='sheet 2'!D4 | Excel Worksheet Functions | |||
| How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
| relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
Linear Mode
