Beautiful, worked like a charm thanks!!

"Hayeso" wrote:

You need to use VLOOKUP function

"smith_gw" wrote:

I am looking to enter a value in a field (say A1) on worksheet b, have that
value found in column a of worksheet a, and pull a value from the same row
but column B and enter it in field A2 of worksheet B. Is there a "simple"
way to do this using a formula directly in the field or will this need to be
done externally in the VB editor or some other fashion.