Is there a replacement of Excell Vlookup function in Access?

[Guest]

I am convirting excell spread sheet with formula's to Access database and I
run into this question how to imitate Vlookup function in Excell. For example
in my excell file that I am trying to convirt to access I have a value of "1"
in cell A1 and
column BL2 has a value of "1", column BM2 has a value of "1 to 4". My excell
function populates cell A2=VLOOKUP(A1,BL2:BM2,2) It looks at the value of "1"
and if it's within the range of "1 to 4" it puts "1 to 4" into cell A2.

How do I do this in Access? Is there another way of doing it except using
"if function"?

Thanks,
Sergey.
(e-mail address removed)

 

[John W. Vinson]

I am convirting excell spread sheet with formula's to Access database and I
run into this question how to imitate Vlookup function in Excell. For example
in my excell file that I am trying to convirt to access I have a value of "1"
in cell A1 and
column BL2 has a value of "1", column BM2 has a value of "1 to 4". My excell
function populates cell A2=VLOOKUP(A1,BL2:BM2,2) It looks at the value of "1"
and if it's within the range of "1 to 4" it puts "1 to 4" into cell A2.

How do I do this in Access? Is there another way of doing it except using
"if function"?

Yes. Use a Query joining two tables.

Access IS NOT A SPREADSHEET and does not work like a spreadsheet. If you'll be
using Access, you may need to "unlearn" a lot of the way "things are always
done" - because in the relational paradigm, things are *not* always done that
way! There is a DLookUp function but it is in NO sense a drop-in substitute
for VLookUp. For one thing, Access doesn't even HAVE "cells"; and if you have
all your data in one huge spreadsheet-like table, you will need to split it up
into two or more properly normalized tables.

John W. Vinson [MVP]