Sep 08 2018 10:38 AM
Hi everyone,
Bit of an newbie here when it comes to boolean, looking for some help building a s sheet.
I've got a lot of sales data for different sites in a sheet, spread across columns (So, C is site 1 and D is site 2 etc...) from a generated report that comes out every week. I'm hoping to get something together where I build a sheet that I can just paste the report into a second book and then have a first sheet that refers to it and pulls out just the sites that I need to see to make it easier to digest.
Ideally, I need to be able to search a row for a specific word and then pull out a cell from the column that the word appears in.
For example: Search Row 1 for the word "Nottingham". It if it appears in 1H, then I want the value of the cell to be equal to 3H. If it appears in 1K, then I want the value of the cell to be 3K and so on.
Any help you could give would be hugely appreciated, thanks!
Sep 08 2018 12:10 PM
I did not understand exactly what you need, but I'm giving you what I understood:
=HLOOKUP(cell with the word you need;A1:Z3 in the sheet with those sites;3;TRUE)