ExcelBanter - Get value of cell next to a target cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Get value of cell next to a target cell (https://www.excelbanter.com/excel-discussion-misc-queries/76966-get-value-cell-next-target-cell.html)

Box815

Get value of cell next to a target cell

How do I get the value of a cell next to a cell with a specific string in it?

Dominic

Get value of cell next to a target cell

I'd use vlookup.

=vlookup("*specific string*",range,2,false)

"Box815" wrote:

How do I get the value of a cell next to a cell with a specific string in it?

All times are GMT +1. The time now is 03:02 AM.