Pulling data from different worksheet
 

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.

Pulling data from different worksheet
 

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.

Pulling data from different worksheet
 

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.