VLookup
Hello everyone.
I've just registered and need some help!
I need to use VLOOKUP to return a value from another cell in another worksheet.
In worksheet 2 cell C9 I need to return a blank if cell C13 in worksheet 1 is blank otherwise return the value of C13 in worksheet 1. This is what I have in C9 :
=IF(sheet1!$C$13="","",VLOOKUP(C9,sheet1!$C$13))
Where am I going wrong?
Last edited by OilcanHoratio; 05-07-2010 at 09:07 PM.
not sure what you want here
but a simple =if(sheet1!c13="","",sheet1!c13) should do
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
That did it. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks