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.