Macro? vlookup? I don't know!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to type a four digit number into sheet 'A.' Then have the function search sheet 'B' to find the matching number, then take the name that corresponds with the number (still in sheet 'B') and have it pop up in sheet 'A.' Does this make any sense? Do I use a macro, vlookup, what!?!
 
Vlookup. this one is straightforward, just follow the directions from
pressing F1 and looking at VLOOKUP.


SNB said:
I am trying to type a four digit number into sheet 'A.' Then have the
Click to expand...
function search sheet 'B' to find the matching number, then take the name
that corresponds with the number (still in sheet 'B') and have it pop up in
sheet 'A.' Does this make any sense? Do I use a macro, vlookup, what!?!
 
Simple VLOOKUP will do.

Assuming SheetB has numbers and names in adjacent columns(say A & B)

In SheetA in B1 enter =VLOOKUP(A1,SheetB!$A$1:$B$10,2,FALSE)

Enter a number in A1 on SheetA and B1 will return the name from SheetB.

Gord Dibben Excel MVP
 
Thanks! I am not sure how to write the formula if I am using two different sheets

----- Dave R. wrote: ----

Vlookup. this one is straightforward, just follow the directions fro
pressing F1 and looking at VLOOKUP


SNB said:
I am trying to type a four digit number into sheet 'A.' Then have th
Click to expand...
function search sheet 'B' to find the matching number, then take the nam
that corresponds with the number (still in sheet 'B') and have it pop up i
sheet 'A.' Does this make any sense? Do I use a macro, vlookup, what!?
 
can we use this technique if we are wanting to retrieve data from a work
book in the same sheet ? and if so how ?
 
Back
Top