Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Thought i knew how to use vlookup. It's been a while since I've used it.
Here's my problem. Got two worksheets, Sheet 1 & Sheet 2. I have catalog numbers on Sheet 1 in ascending order (column A). I want to see if those same numbers are on Sheet 2 (column F). Want the results in column 8 (H) on Sheet 1. Forumla= (A2,F2-F3495,8,0). I got an N/A in cell H2 and when I copied the formula down It had the same thing in all the cells. What am I doing wrong? Thanks ahead of time. -- thanks, idcreek |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Vlookup Problem | Excel Worksheet Functions | |||
VLOOKUP problem | Excel Discussion (Misc queries) | |||
Problem with VLOOKUP and drop-down lists! | Excel Worksheet Functions | |||
VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions | |||
VLOOKUP problem | Excel Worksheet Functions |