D
Don
Hi All,
Is it possible to pull data from another sheet using the
VLOOKUP function? I've looked at "Indirect", but that
seems to rely on typing in the name of another Sheet.
What I'd like to do is to establish a range of answers
(both text and numerical). This range would include
possibly 5-6 different responses to "Y" or "N" inputs. I
would like to put this range on a seperate sheet, let's
say Sheet2. Then on Sheet1 call a VLOOKUP dependent on
a "Y" or "N" in one cell, which would insert the
appropriate answer in another cell on Sheet1. This would
occur across Sheet1 in several locations and the
appropriate text/number would be pulled from Sheet2.
What I envision is a range set up something like this:
A1: Y B1: "text" C1: "text" D1: "value"
A2: N B2: "text" C2: "text" D2: "value"
Also might be entries in "E", "F" and so on, but if I get
this much sorted out, if it can be done, I can add to the
list.
Reason for doing this is that Sheet1 is to be sorted in
several different ways for different Invoice functions.
This would keep the LOOKUP range out of the sort.
I've managed to do this with nested "IF" functions so
far, but in some cases they become rather lengthy. If
there's an easier way, please let me know.
Hope this makes sense......be easy on me guys/gals...rank
beginner here.
Don.....dang, this got lengthy
Is it possible to pull data from another sheet using the
VLOOKUP function? I've looked at "Indirect", but that
seems to rely on typing in the name of another Sheet.
What I'd like to do is to establish a range of answers
(both text and numerical). This range would include
possibly 5-6 different responses to "Y" or "N" inputs. I
would like to put this range on a seperate sheet, let's
say Sheet2. Then on Sheet1 call a VLOOKUP dependent on
a "Y" or "N" in one cell, which would insert the
appropriate answer in another cell on Sheet1. This would
occur across Sheet1 in several locations and the
appropriate text/number would be pulled from Sheet2.
What I envision is a range set up something like this:
A1: Y B1: "text" C1: "text" D1: "value"
A2: N B2: "text" C2: "text" D2: "value"
Also might be entries in "E", "F" and so on, but if I get
this much sorted out, if it can be done, I can add to the
list.
Reason for doing this is that Sheet1 is to be sorted in
several different ways for different Invoice functions.
This would keep the LOOKUP range out of the sort.
I've managed to do this with nested "IF" functions so
far, but in some cases they become rather lengthy. If
there's an easier way, please let me know.
Hope this makes sense......be easy on me guys/gals...rank
beginner here.
Don.....dang, this got lengthy