Matchin columns in another sheet
Closed
mr
-
Dec 18, 2009 at 12:52 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 18, 2009 at 08:19 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 18, 2009 at 08:19 PM
Hello,
I have a document with several worksheets. One is meant to be a total count, encompassing all the others.
I need to know how to get the total sheet to automatically populate the values listed in the corresponding columns on the other pages. I tried to just do = corresponding column in the page, but issues occur when the pages are sorted differently. I also tried vlook up but because cant get that to work either.
In essence, I need a formula that will look up a name in column a find that name on sheet 2, and return the info listed in column b for that name.
Please help.
I have a document with several worksheets. One is meant to be a total count, encompassing all the others.
I need to know how to get the total sheet to automatically populate the values listed in the corresponding columns on the other pages. I tried to just do = corresponding column in the page, but issues occur when the pages are sorted differently. I also tried vlook up but because cant get that to work either.
In essence, I need a formula that will look up a name in column a find that name on sheet 2, and return the info listed in column b for that name.
Please help.
Related:
- Matchin columns in another sheet
- Sheet right to left in google sheet - Guide
- Windows network commands cheat sheet - Guide
- Tweetdeck larger columns - Guide
- Mark sheet in excel - Guide
- Display two columns in data validation list but return only one - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 18, 2009 at 08:19 PM
Dec 18, 2009 at 08:19 PM
how did you do the =formula
you enter soemthinglike as
=sheet2!a1
in the totoalcount sheet
I suppose it does not matter how you sort the sheets because sheet2 is specific name for that sheet.
you enter soemthinglike as
=sheet2!a1
in the totoalcount sheet
I suppose it does not matter how you sort the sheets because sheet2 is specific name for that sheet.
