ExcelBanter - Return text between look up function.

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Return text between look up function. (https://www.excelbanter.com/excel-worksheet-functions/244374-return-text-between-look-up-function.html)

Rspiva

Return text between look up function.

I have a formula shown below, where I want to return a populated field from a
csv file but between the 2 look up returns I would like to display "X".

General Im trying to display a width X length in another work sheet.

=(dyCAR.csv!$D$9) X (dyCAR.csv!$D$11)

Eduardo

Return text between look up function.

Hi,

=(dyCAR.csv!$D$9)&"X"&(dyCAR.csv!$D$11)

"Rspiva" wrote:

I have a formula shown below, where I want to return a populated field from a
csv file but between the 2 look up returns I would like to display "X".

General Im trying to display a width X length in another work sheet.

=(dyCAR.csv!$D$9) X (dyCAR.csv!$D$11)

Jacob Skaria

Return text between look up function.

Do you mean

=dyCAR.csv!$D$9 & "X" & dyCAR.csv!$D$11

If this post helps click Yes
---------------
Jacob Skaria

"Rspiva" wrote:

I have a formula shown below, where I want to return a populated field from a
csv file but between the 2 look up returns I would like to display "X".

General Im trying to display a width X length in another work sheet.

=(dyCAR.csv!$D$9) X (dyCAR.csv!$D$11)

All times are GMT +1. The time now is 04:49 AM.