Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup
I'm working with Excel 2003 and created a workbook (1 worksheet) to compare 3
columns of data. Each column varies in number of rows, but could have as many as 800 lines. Two problems (although minor, as I have a work-around to resolve), but I am wondering if there is a better way to do it. Columns C, D & E have the data I need to compare. In Column A there is a VLookup formula that compares C & D to find a match. Then in Column B, I did another VLookup formula that looks for a match for the results of Column A & E. It works, but possibly there is a better solution. Second problem, each day we are copying a new set of data into the next blank column (F), then deleting Column C, so that we always have only 3 columns. Of course when Column C is deleted, the formula goes to REF#. I did a work around by writing a small macro that re-inputs the formulas into Columns A & B. Is there any way to retain the formula? Thanks for any help. -- Linda |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |