get value from cell next to that of searched text

[SBS user]

I have some tables where there is a veriable in a cell next to searchable
text. So if I search for the desired text and want to take the value of the
cell to the left of it what would that formula look like?

 

[Don Guillett]

Look in the help index for MATCH and then for INDEX

 

[SBS user]

That gives good information for a single sheet, but what if I want to do it
for multiple sheets at a time?

 

[Don Guillett]

More info or
If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.

 

[SBS user]

thanks for hte pointer

Look in the help index for MATCH and then for INDEX

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)