I have numbers on one sheet and need to get them to another spredsheet.
There is a common ID for each corresponding number on both sheets. Basically
I need to ask if X occurs Y (from the other spreadsheet) needs to appear in
the selected field.
I have numbers on one sheet and need to get them to another spredsheet.
There is a common ID for each corresponding number on both sheets. Basically
I need to ask if X occurs Y (from the other spreadsheet) needs to appear in
the selected field.
It sounds like you want =vlookup() or =index(match())
Take a look at Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html
and
http://www.contextures.com/xlFunctions03.html
SLH wrote:
>
> I have numbers on one sheet and need to get them to another spredsheet.
> There is a common ID for each corresponding number on both sheets. Basically
> I need to ask if X occurs Y (from the other spreadsheet) needs to appear in
> the selected field.
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks