Help with a vlookup.

tjarvas · #1 (**permalink**) 03-11-04, 09:44

Can anyone here help me i writting a vlookup function for an excel spreadsheet?

Smitty · #2 (**permalink**) 03-11-04, 12:17

Here's an example I put together for someone else. Hope that helps,

Smitty

tjarvas · #3 (**permalink**) 03-11-04, 13:56

Can you take a look at this. This is a miny version of what I am trying to do.

Smitty · #4 (**permalink**) 03-11-04, 14:00

Use this formula instead:

=VLOOKUP(A2,Leases!A

,COLUMN(),FALSE)

EDIT: Damn smiley got in the way. Should be A : D w/o the spaces.

Note that it would be better for recalculation to narrow the A

range as right now you're forcing Excel to look through 65,536 x 2 rows.

Hope that helps,

Smitty

tjarvas · #5 (**permalink**) 03-11-04, 14:06

Sweet, that worked. God I love this forum.