Can a VLOOKUP formula be copied to another sheet within the workbook?
I have a VLOOKUP formula that i'm trying to copy to another sheet, within the workbook, and i've tried these factors:
1)...'Sheet1'!+VLOOKUP(A1,B1:C8,2,FALSE) = No Action
2)...+'Sheet1'!VLOOKUP(A1,B1:C8,2,FALSE) = Error Message
3)...+VLOOKUP('Sheet1'!A1,B1:C8,2,FALSE) = Value Not Available Error
What am I doing wrong, and is this even possible to do?
Last edited by clogistics; 12-20-2015 at 07:37 PM.
Not clear to me what you are trying to do: can you post a small sample excel file?
I've created a test file attachmentOriginally Posted by JohnTopley
Is this what you want ?
In Sheet2
=10*2+1.25+VLOOKUP(Sht,INDIRECT(Sht &"!E3:F4"),2,FALSE)
"Sht" is named range for B4 on Sheet1
I unmerged the cells in the drop-down
I'm getting a #REF! error when I input your, recommended, formula.
See attached.
You will get #N/A error if Sheet2 is chosen as there is no table in Sheet2.
Still not sure what you are trying to achieve.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks