Hi all
I'm trying to set what is probably a very basic vlookup instruction but have no idea. I've never used vlookup before - I've only just discovered conditional formatting!
Anyway, I would like to do the following:
If a cell in column F contains 'y' I would like to copy the data from column B to column H in the same row.
Any help with this would be greatly appreciated. Many thanks in advance.
Try:
Look on the Net - Click on the words "Look on the Net" to the left as it sends you to a youtube training of Vlookup.
Last edited by MarvinP; 08-26-2010 at 07:58 PM.
Please attach a dummy worksheet for the forum users to help you out/explain the equations.
Perhaps in H2:
=IF(F2="y", B2, "")
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
This works perfectly, thank you so much!!Originally Posted by JBeaucaire
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
While you're in there, change this thread title, too, this may win the award for the worst title of the week!Something like "IF/THEN on every row"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks