how to return the corresponding value

D

devdutt_dev

Hi Friends,

NEED HELP DESPERATLY......

col A col B col C col D
laptop h/w
desktop h/w
HDD h/w
RAM h/w
CPU h/w
Ms office s/w
adobe s/w
acrobat s/w
macromedia s/w

what i want to do is : if i enter any value from col A then it shoul
return the corresponding value in col B in col D

any suggestions???

Thank
 
J

Jason Morin

This'll work...

=VLOOKUP(C1,A:B,2,0)

where C1 holds the value to look up.

HTH
Jason
Atlanta, GA
 
M

Max

Please do not multi-post ..
See your post in .programming
I've suggested a way to clean up your lookup col A
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to match 1 value to multiple columns 10
Function or Sub to help with text string 5
vlookup against one of two options? 3
how to place an item in different cells matching two criterias 2
how to return the value of a cell based on two criterias in two columns 1
Selcting data from table without repeating plus calc's 2
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
match-up formula 3

Top