| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel function
Hi,
Let's say that in Sheet2 you have your data i.e. George 100 Alan 200 Names are in column A and values in Column B so in sheet 1 the idea is once entered George in A1 in B1 will retrieve the value 200 Formula to enter in B1 is =+VLOOKUP(A3,Sheet2!A:B,2,FALSE) Where 2 is the column where you need to retrieve the data hope this help if yes please said yes "mark3947" wrote: I would like to create my own worksheet function to do a vlookup. Does someone have an example that will work? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help to build a Look Up Function or What Ever Function Excel 2002 | Excel Worksheet Functions | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| challenge! javascript function into excel function | Excel Worksheet Functions | |||
| Excel Workday Function with another function | Excel Discussion (Misc queries) | |||
| Can you nest a MID function within a IF function in Excel | Excel Worksheet Functions | |||
Hybrid Mode
